Document Library

  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC ) count_alias' at line 20 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, node_data_field_url.field_url_url AS node_data_field_url_field_url_url, node_data_field_url.field_url_title AS node_data_field_url_field_url_title, node_data_field_url.field_url_attributes AS node_data_field_url_field_url_attributes, node.type AS node_type, node.vid AS node_vid, node_data_field_url.field_date_published_value AS node_data_field_url_field_date_published_value, node_data_field_url.field_month_published_value AS node_data_field_url_field_month_published_value, node.title AS node_title, node_data_field_url.field_author_value AS node_data_field_url_field_author_value, node_data_field_url.field_document_text_tags_value AS node_data_field_url_field_document_text_tags_value, location_continent.continent AS location_continent_continent FROM drp_node node INNER JOIN drp_term_node term_node ON node.vid = term_node.vid LEFT JOIN drp_content_type_bldr_document node_data_field_url ON node.vid = node_data_field_url.vid LEFT JOIN drp_location_instance location_instance ON node.vid = location_instance.vid LEFT JOIN drp_location_continent location_continent ON location_instance.lid = location_continent.lid WHERE (node.type in ('bldr_document')) AND (term_node.tid = 243) GROUP BY nid ORDER BY ASC ) count_alias in /home5/imtorg/public_html/buildingrating/sites/all/modules/contrib/views/includes/view.inc on line 805.
  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 0, 20' at line 20 query: SELECT DISTINCT(node.nid) AS nid, node_data_field_url.field_url_url AS node_data_field_url_field_url_url, node_data_field_url.field_url_title AS node_data_field_url_field_url_title, node_data_field_url.field_url_attributes AS node_data_field_url_field_url_attributes, node.type AS node_type, node.vid AS node_vid, node_data_field_url.field_date_published_value AS node_data_field_url_field_date_published_value, node_data_field_url.field_month_published_value AS node_data_field_url_field_month_published_value, node.title AS node_title, node_data_field_url.field_author_value AS node_data_field_url_field_author_value, node_data_field_url.field_document_text_tags_value AS node_data_field_url_field_document_text_tags_value, location_continent.continent AS location_continent_continent FROM drp_node node INNER JOIN drp_term_node term_node ON node.vid = term_node.vid LEFT JOIN drp_content_type_bldr_document node_data_field_url ON node.vid = node_data_field_url.vid LEFT JOIN drp_location_instance location_instance ON node.vid = location_instance.vid LEFT JOIN drp_location_continent location_continent ON location_instance.lid = location_continent.lid WHERE (node.type in ('bldr_document')) AND (term_node.tid = 243) GROUP BY nid ORDER BY ASC LIMIT 0, 20 in /home5/imtorg/public_html/buildingrating/sites/all/modules/contrib/views/includes/view.inc on line 810.